home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
veventspart4.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
3KB
|
54 lines
/*
This is one of the constituent views of vallevents... collecting all events together.
*/
create or replace view veventspart4 as
select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, rpad('(28) Pset Time', 200) event
from psettime
union
select DET_SEQ_NUM ,FAREBOX_GLID, CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , ROUTE_ID,
RUN_ID, TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(29) Route Chg' event
from rtechng
union select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(30) SBill override Off' event
from sboveroff
union select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm,
'(31) SBill override On ' || to_char(currency_type) || ' ' || to_char(0.01 * currency_val, '99.99') event
from sboveron
union
select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE, 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(32) Set time' event
from settime
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID, ROUTE_ID,
RUN_ID, TRIP_ID, FARESET_ID ,' ' setclr,0 alarm, '(33) Shift End ' event
from shftend
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr,0 alarm,'(34) ShiftRelEnd ' event
from shftrele
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID ,' ' setclr, 0 alarm,'(35) ShiftRelStart' event
from shftrels
union
select DET_SEQ_NUM, FAREBOX_GLID, CONV_DATE, SHIFT_SEQ, USER_ID, ROUTE_ID,
RUN_ID, TRIP_ID, FARESET_ID ,' ' setclr, 0 alarm,'(36) Shift Start' event
from shftstrt
union
select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(37) Stake Time' event
from staket
union
select DET_SEQ_NUM ,FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm, '(38) Startup' event
from startup
union
select DET_SEQ_NUM, FAREBOX_GLID ,CONV_DATE , 0 SHIFT_SEQ, 0 USER_ID , 0 ROUTE_ID,
0 RUN_ID, 0 TRIP_ID, 0 FARESET_ID , ' ' setclr, 0 alarm,
'(39) Suprv Security ' || ocucmnd.descr || ', user_id= ' || to_char(user_id, '999999.') event
from supersec, ocucmnd
where supersec.command_id = ocucmnd.id;